﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 礼品管理实体类：fanli_gift 。
	/// </summary>
	[Serializable]
	public class fanli_gift
	{
		public fanli_gift()
		{}

		#region Model
		private int _id; //id
		private int _parentCataid; //父分类id
		private int _cataid; //子分类id
		private string _giftName; //礼品名称
		private string _picurl; //图片地址
		private string _about; //介绍
		private string _notice; //注意事项
		private int _score; //所需积分
		private float _money; //所需返利
		private int _remainNum; //库存量
		private string _useCondition; //使用条件
		private int _hasSaleNum; //已兑换数量
		private string _restriction; //兑换限制
		private string _exchangeCondition; //兑换条件
		private int _ishot; //热门推荐
		private int _sortid; //排序
		private int _status; //状态
		private int _shopID; //关联商城id
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 父分类id
		/// </summary>
		public int parentCataid
		{
			set{ _parentCataid=value;}
			get{return _parentCataid;}
		}
        /// <summary>
		/// 子分类id
		/// </summary>
		public int cataid
		{
			set{ _cataid=value;}
			get{return _cataid;}
		}
        /// <summary>
		/// 礼品名称
		/// </summary>
		public string giftName
		{
			set{ _giftName=value;}
			get{return _giftName;}
		}
        /// <summary>
		/// 图片地址
		/// </summary>
		public string picurl
		{
			set{ _picurl=value;}
			get{return _picurl;}
		}
        /// <summary>
		/// 介绍
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
        /// <summary>
		/// 注意事项
		/// </summary>
		public string notice
		{
			set{ _notice=value;}
			get{return _notice;}
		}
        /// <summary>
		/// 所需积分
		/// </summary>
		public int score
		{
			set{ _score=value;}
			get{return _score;}
		}
        /// <summary>
		/// 所需返利
		/// </summary>
		public float money
		{
			set{ _money=value;}
			get{return _money;}
		}
        /// <summary>
		/// 库存量
		/// </summary>
		public int remainNum
		{
			set{ _remainNum=value;}
			get{return _remainNum;}
		}
        /// <summary>
		/// 使用条件
		/// </summary>
		public string useCondition
		{
			set{ _useCondition=value;}
			get{return _useCondition;}
		}
        /// <summary>
		/// 已兑换数量
		/// </summary>
		public int hasSaleNum
		{
			set{ _hasSaleNum=value;}
			get{return _hasSaleNum;}
		}
        /// <summary>
		/// 兑换限制
		/// </summary>
		public string restriction
		{
			set{ _restriction=value;}
			get{return _restriction;}
		}
        /// <summary>
		/// 兑换条件
		/// </summary>
		public string exchangeCondition
		{
			set{ _exchangeCondition=value;}
			get{return _exchangeCondition;}
		}
        /// <summary>
		/// 热门推荐
		/// </summary>
		public int ishot
		{
			set{ _ishot=value;}
			get{return _ishot;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 关联商城id
		/// </summary>
		public int shopID
		{
			set{ _shopID=value;}
			get{return _shopID;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
礼品管理,gift
id,父分类id,子分类id,礼品名称,图片地址,介绍,注意事项,所需积分,所需返利,库存量,使用条件,已兑换数量,兑换限制,兑换条件,热门推荐,排序,状态,关联商城id,扩展1,扩展2
id,parentCataid,cataid,giftName,picurl,about,notice,score,money,remainNum,useCondition,hasSaleNum,restriction,exchangeCondition,ishot,sortid,status,shopID,ext1,ext2
i,i,i,c100,c256,t,c800,i,f,i,c200,i,c500,c400,i,i,i,i,c100,c100

--------------------------
-- 创建表[礼品管理]开始: 
-- alter table  [fanli_gift] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_gift') drop table fanli_gift
  CREATE TABLE [fanli_gift] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [parentCataid] int,
	 [cataid] int,
	 [giftName] [varchar] (100),
	 [picurl] [varchar] (256),
	 [about] [text],
	 [notice] [varchar] (800),
	 [score] int,
	 [money] [float],
	 [remainNum] int,
	 [useCondition] [varchar] (200),
	 [hasSaleNum] int,
	 [restriction] [varchar] (500),
	 [exchangeCondition] [varchar] (400),
	 [ishot] int,
	 [sortid] int,
	 [status] int,
	 [shopID] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'礼品管理 ',N'user',N'dbo',N'table',N'fanli_gift', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'父分类id',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'parentCataid'
 exec sp_addextendedproperty N'MS_Description',N'子分类id',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'cataid'
 exec sp_addextendedproperty N'MS_Description',N'礼品名称',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'giftName'
 exec sp_addextendedproperty N'MS_Description',N'图片地址',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'picurl'
 exec sp_addextendedproperty N'MS_Description',N'介绍',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'about'
 exec sp_addextendedproperty N'MS_Description',N'注意事项',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'notice'
 exec sp_addextendedproperty N'MS_Description',N'所需积分',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'score'
 exec sp_addextendedproperty N'MS_Description',N'所需返利',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'money'
 exec sp_addextendedproperty N'MS_Description',N'库存量',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'remainNum'
 exec sp_addextendedproperty N'MS_Description',N'使用条件',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'useCondition'
 exec sp_addextendedproperty N'MS_Description',N'已兑换数量',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'hasSaleNum'
 exec sp_addextendedproperty N'MS_Description',N'兑换限制',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'restriction'
 exec sp_addextendedproperty N'MS_Description',N'兑换条件',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'exchangeCondition'
 exec sp_addextendedproperty N'MS_Description',N'热门推荐',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'ishot'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'sortid'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'关联商城id',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'shopID'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_gift',N'column',N'ext2'

-- 创建表[礼品管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

